Release 10.1A: OpenEdge Data Management:
SQL Reference


Scalar functions

Table 66, Table 67, and Table 68 list the scalar functions that ODBC supports. You can use these functions in SQL statements using the following syntax:

Syntax
{fn scalar-function} 

scalar-function is one of the functions listed in the following tables. For example:

SELECT {fn UCASE(NAME)} FROM EMP 


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095